{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>.container { width:100% !important; }</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                              持买仓量\n",
      "date       variety 持买仓量期货公司       \n",
      "2018-01-02 B       北京金鹏       13.0\n",
      "           I       北京金鹏      150.0\n",
      "2018-01-03 B       北京金鹏       14.0\n",
      "           I       北京金鹏      150.0\n",
      "2018-01-04 I       北京金鹏      150.0\n",
      "                              持卖仓量\n",
      "date       variety 持卖仓量期货公司       \n",
      "2018-01-02 CS      北京金鹏      406.0\n",
      "           I       北京金鹏      150.0\n",
      "           JD      北京金鹏      263.0\n",
      "2018-01-03 CS      北京金鹏      391.0\n",
      "           I       北京金鹏      150.0\n",
      "         date variety  会员简称   持买仓量   持卖仓量   净持仓\n",
      "0  2018-01-02       B  北京金鹏   13.0    0.0  13.0\n",
      "1  2018-01-02       I  北京金鹏  150.0  150.0   0.0\n",
      "2  2018-01-03       B  北京金鹏   14.0    0.0  14.0\n",
      "3  2018-01-03       I  北京金鹏  150.0  150.0   0.0\n",
      "4  2018-01-04       I  北京金鹏  150.0  150.0   0.0\n",
      "         date variety  contractValue\n",
      "0  2018-05-04       A        38330.0\n",
      "1  2018-05-04      AG        55380.0\n",
      "2  2018-05-04      AL        73100.0\n",
      "3  2018-05-04      AP        82150.0\n",
      "4  2018-05-04      AU       272000.0\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>variety</th>\n",
       "      <th>A</th>\n",
       "      <th>B</th>\n",
       "      <th>C</th>\n",
       "      <th>CS</th>\n",
       "      <th>I</th>\n",
       "      <th>JD</th>\n",
       "      <th>M</th>\n",
       "      <th>P</th>\n",
       "      <th>Y</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>会员简称</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-01-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>425620</td>\n",
       "      <td>0</td>\n",
       "      <td>-8692460</td>\n",
       "      <td>0</td>\n",
       "      <td>-10238590</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-03</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>459200</td>\n",
       "      <td>0</td>\n",
       "      <td>-8465150</td>\n",
       "      <td>0</td>\n",
       "      <td>-10183950</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-04</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-36530</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-10152150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-10046600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6805200</td>\n",
       "      <td>0</td>\n",
       "      <td>-9910560</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28100000</td>\n",
       "      <td>-9877400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6165400</td>\n",
       "      <td>27900000</td>\n",
       "      <td>-9848580</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-36530</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27850000</td>\n",
       "      <td>-9840720</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27304500</td>\n",
       "      <td>-9838100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-36710</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7811000</td>\n",
       "      <td>53800</td>\n",
       "      <td>-9788320</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-982800</td>\n",
       "      <td>0</td>\n",
       "      <td>53100</td>\n",
       "      <td>-9694000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-35980</td>\n",
       "      <td>0</td>\n",
       "      <td>-907000</td>\n",
       "      <td>0</td>\n",
       "      <td>53200</td>\n",
       "      <td>-9699240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-35920</td>\n",
       "      <td>0</td>\n",
       "      <td>-903500</td>\n",
       "      <td>0</td>\n",
       "      <td>53800</td>\n",
       "      <td>-9796180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-714400</td>\n",
       "      <td>0</td>\n",
       "      <td>52300</td>\n",
       "      <td>-8487530</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-01</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-5214000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50700</td>\n",
       "      <td>-8154060</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>-5202000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51400</td>\n",
       "      <td>-8120760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52700</td>\n",
       "      <td>-8240640</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-871680</td>\n",
       "      <td>-16639250</td>\n",
       "      <td>52500</td>\n",
       "      <td>-8258400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2829500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1743360</td>\n",
       "      <td>-13170300</td>\n",
       "      <td>52400</td>\n",
       "      <td>-8251740</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2820000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3451370</td>\n",
       "      <td>-14189680</td>\n",
       "      <td>52400</td>\n",
       "      <td>-8398260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-3402900</td>\n",
       "      <td>-12404340</td>\n",
       "      <td>53000</td>\n",
       "      <td>-8429340</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-2836500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1480920</td>\n",
       "      <td>0</td>\n",
       "      <td>54000</td>\n",
       "      <td>-8300580</td>\n",
       "      <td>29480</td>\n",
       "      <td>0</td>\n",
       "      <td>-2845000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1924930</td>\n",
       "      <td>0</td>\n",
       "      <td>55000</td>\n",
       "      <td>-8495940</td>\n",
       "      <td>29470</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8553660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-979560</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7750540</td>\n",
       "      <td>29570</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-911000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7758660</td>\n",
       "      <td>29940</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-01</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-904500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7811440</td>\n",
       "      <td>30380</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7584080</td>\n",
       "      <td>31000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-06</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7618590</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-07</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7970050</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8008750</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8058200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8728280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5558310</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-14</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5594550</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6605280</td>\n",
       "      <td>211120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-9644210</td>\n",
       "      <td>213430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-11049840</td>\n",
       "      <td>210420</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-10681440</td>\n",
       "      <td>239120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-21</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-10194240</td>\n",
       "      <td>210070</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-10250480</td>\n",
       "      <td>210280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-11063160</td>\n",
       "      <td>976000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-11186930</td>\n",
       "      <td>1019370</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6772370</td>\n",
       "      <td>1100880</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5242500</td>\n",
       "      <td>1248450</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-29</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-4429100</td>\n",
       "      <td>1298170</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-30</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8106600</td>\n",
       "      <td>1009280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8226960</td>\n",
       "      <td>1009920</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-03</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8278880</td>\n",
       "      <td>1010560</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-04</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>23384270</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-8420480</td>\n",
       "      <td>932930</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6822720</td>\n",
       "      <td>1006880</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-6901840</td>\n",
       "      <td>49955940</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48658080</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>46635660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7390240</td>\n",
       "      <td>48854770</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35554220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-7066240</td>\n",
       "      <td>48446260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34280290</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>65280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36915120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37085040</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37042560</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64060</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36978840</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36936360</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>64000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36749130</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63520</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36423960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-14</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61103700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-21</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18023910</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-58157400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-140577000</td>\n",
       "      <td>0</td>\n",
       "      <td>-64097000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-72394520</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-143444000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-71993220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142504000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-76940600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142974000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-29</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-79523640</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-144948000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-30</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-78996120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-143773000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-31</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-65015200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142598000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14421090</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142974000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-04</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13554000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-143820000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8792040</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142410000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-06</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5871200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-141940000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-07</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>519970</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-141094000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8976240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-137737600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9237330</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-137851000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-58536960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-137945000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>195470</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-139496000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-14</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61646220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-140154000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-63189280</td>\n",
       "      <td>0</td>\n",
       "      <td>14190000</td>\n",
       "      <td>0</td>\n",
       "      <td>-139590000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-63100080</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-144525000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-63366720</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-143726000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-21</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-67038840</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142128000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-67890660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-140624000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-62881280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-142034000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-62764850</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-144384000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61909650</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147298000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61743200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147298000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-29</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-62143520</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148426000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-62052720</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-150165000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-03</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61980080</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148473000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-04</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-62014210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147533000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61604650</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147815000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-06</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-61877690</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-146546000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-63931200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-146640000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-64699220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148025000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148311500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-149140750</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>17869620</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147596750</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>17917230</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148031000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-149382000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147452000</td>\n",
       "      <td>0</td>\n",
       "      <td>231935040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>-67960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-147895130</td>\n",
       "      <td>0</td>\n",
       "      <td>225791900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-148846530</td>\n",
       "      <td>0</td>\n",
       "      <td>227600100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34590</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-195781530</td>\n",
       "      <td>0</td>\n",
       "      <td>229073740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-200007000</td>\n",
       "      <td>0</td>\n",
       "      <td>234666460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34870</td>\n",
       "      <td>36793900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-204081020</td>\n",
       "      <td>0</td>\n",
       "      <td>231469410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34970</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-198922230</td>\n",
       "      <td>0</td>\n",
       "      <td>354545100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34530</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-256078800</td>\n",
       "      <td>0</td>\n",
       "      <td>439384500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-30</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34590</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-279818100</td>\n",
       "      <td>0</td>\n",
       "      <td>461909280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-31</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34150</td>\n",
       "      <td>37260630</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-280518740</td>\n",
       "      <td>0</td>\n",
       "      <td>462099880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-01</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34340</td>\n",
       "      <td>37161640</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-277130450</td>\n",
       "      <td>-132851480</td>\n",
       "      <td>500488800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34420</td>\n",
       "      <td>37181760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-281654250</td>\n",
       "      <td>0</td>\n",
       "      <td>509504040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-03</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>33860</td>\n",
       "      <td>37019070</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-280732760</td>\n",
       "      <td>0</td>\n",
       "      <td>507191700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-06</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34300</td>\n",
       "      <td>36666900</td>\n",
       "      <td>0</td>\n",
       "      <td>211327200</td>\n",
       "      <td>0</td>\n",
       "      <td>-281565540</td>\n",
       "      <td>0</td>\n",
       "      <td>505818720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-07</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>34590</td>\n",
       "      <td>36572650</td>\n",
       "      <td>0</td>\n",
       "      <td>257186300</td>\n",
       "      <td>0</td>\n",
       "      <td>-290368000</td>\n",
       "      <td>0</td>\n",
       "      <td>509745600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>290308200</td>\n",
       "      <td>0</td>\n",
       "      <td>-295173450</td>\n",
       "      <td>0</td>\n",
       "      <td>523350720</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>293025600</td>\n",
       "      <td>0</td>\n",
       "      <td>-295526120</td>\n",
       "      <td>0</td>\n",
       "      <td>539427480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21071160</td>\n",
       "      <td>0</td>\n",
       "      <td>258975600</td>\n",
       "      <td>0</td>\n",
       "      <td>-296175360</td>\n",
       "      <td>0</td>\n",
       "      <td>551308800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>155565300</td>\n",
       "      <td>0</td>\n",
       "      <td>-288471700</td>\n",
       "      <td>0</td>\n",
       "      <td>552483150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-14</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>443270100</td>\n",
       "      <td>0</td>\n",
       "      <td>-289267200</td>\n",
       "      <td>0</td>\n",
       "      <td>558017200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>416282800</td>\n",
       "      <td>0</td>\n",
       "      <td>-295061080</td>\n",
       "      <td>0</td>\n",
       "      <td>562629450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>408883800</td>\n",
       "      <td>0</td>\n",
       "      <td>-281546400</td>\n",
       "      <td>0</td>\n",
       "      <td>551248700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>613272000</td>\n",
       "      <td>0</td>\n",
       "      <td>-281559790</td>\n",
       "      <td>0</td>\n",
       "      <td>548551500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>767547300</td>\n",
       "      <td>0</td>\n",
       "      <td>-281265780</td>\n",
       "      <td>0</td>\n",
       "      <td>537142400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-21</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>826116200</td>\n",
       "      <td>0</td>\n",
       "      <td>-278529030</td>\n",
       "      <td>0</td>\n",
       "      <td>537889040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>787979500</td>\n",
       "      <td>0</td>\n",
       "      <td>-277684470</td>\n",
       "      <td>0</td>\n",
       "      <td>523514800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>791180200</td>\n",
       "      <td>0</td>\n",
       "      <td>-272229000</td>\n",
       "      <td>0</td>\n",
       "      <td>522770600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>795564000</td>\n",
       "      <td>0</td>\n",
       "      <td>-271260250</td>\n",
       "      <td>0</td>\n",
       "      <td>517844840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>561579600</td>\n",
       "      <td>0</td>\n",
       "      <td>-263290320</td>\n",
       "      <td>0</td>\n",
       "      <td>515843600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>587750800</td>\n",
       "      <td>0</td>\n",
       "      <td>-264640200</td>\n",
       "      <td>0</td>\n",
       "      <td>517462400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-29</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>586771900</td>\n",
       "      <td>0</td>\n",
       "      <td>-265750840</td>\n",
       "      <td>0</td>\n",
       "      <td>492486380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-30</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>442126000</td>\n",
       "      <td>0</td>\n",
       "      <td>-271257600</td>\n",
       "      <td>0</td>\n",
       "      <td>491701540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-31</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>392850000</td>\n",
       "      <td>0</td>\n",
       "      <td>-271821330</td>\n",
       "      <td>0</td>\n",
       "      <td>488268440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-03</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>390830000</td>\n",
       "      <td>0</td>\n",
       "      <td>-275798820</td>\n",
       "      <td>0</td>\n",
       "      <td>493710600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-04</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>394743200</td>\n",
       "      <td>0</td>\n",
       "      <td>-275709910</td>\n",
       "      <td>0</td>\n",
       "      <td>504084060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>393690800</td>\n",
       "      <td>0</td>\n",
       "      <td>-273384160</td>\n",
       "      <td>0</td>\n",
       "      <td>501106760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-06</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>405465400</td>\n",
       "      <td>0</td>\n",
       "      <td>-274208380</td>\n",
       "      <td>0</td>\n",
       "      <td>502589400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-07</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>402682800</td>\n",
       "      <td>0</td>\n",
       "      <td>-274443000</td>\n",
       "      <td>0</td>\n",
       "      <td>505790420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>405253800</td>\n",
       "      <td>0</td>\n",
       "      <td>-246599840</td>\n",
       "      <td>0</td>\n",
       "      <td>526669170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>399897600</td>\n",
       "      <td>0</td>\n",
       "      <td>-247727570</td>\n",
       "      <td>0</td>\n",
       "      <td>526457000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>398323200</td>\n",
       "      <td>0</td>\n",
       "      <td>-183615530</td>\n",
       "      <td>0</td>\n",
       "      <td>525325500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-13</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>407731800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-14</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>406361100</td>\n",
       "      <td>0</td>\n",
       "      <td>-152439660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>405900000</td>\n",
       "      <td>0</td>\n",
       "      <td>-153566240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>410011800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>301787640</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>407181600</td>\n",
       "      <td>0</td>\n",
       "      <td>-155831100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-20</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>404307000</td>\n",
       "      <td>0</td>\n",
       "      <td>-154641280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-21</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>404106600</td>\n",
       "      <td>0</td>\n",
       "      <td>-154005600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>402470600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>407450000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-27</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>422055000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-28</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>399379200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-08</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>402094200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-09</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>411475600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-10</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>467980500</td>\n",
       "      <td>0</td>\n",
       "      <td>-163667160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-11</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>467200000</td>\n",
       "      <td>0</td>\n",
       "      <td>-164819900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-12</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>470334000</td>\n",
       "      <td>0</td>\n",
       "      <td>-163198800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-15</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>542742000</td>\n",
       "      <td>0</td>\n",
       "      <td>-162337600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-16</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>513988200</td>\n",
       "      <td>0</td>\n",
       "      <td>-164388980</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-17</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>527236300</td>\n",
       "      <td>0</td>\n",
       "      <td>-164485650</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-18</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>525427100</td>\n",
       "      <td>0</td>\n",
       "      <td>-163692240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-19</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>602723700</td>\n",
       "      <td>0</td>\n",
       "      <td>-160611450</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-22</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>619944400</td>\n",
       "      <td>0</td>\n",
       "      <td>-159364330</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-23</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>610914900</td>\n",
       "      <td>0</td>\n",
       "      <td>-159123380</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-24</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>547091000</td>\n",
       "      <td>0</td>\n",
       "      <td>-158669840</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-25</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>500133200</td>\n",
       "      <td>0</td>\n",
       "      <td>-161634980</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-26</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>553969200</td>\n",
       "      <td>0</td>\n",
       "      <td>-161710120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-29</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>553593300</td>\n",
       "      <td>0</td>\n",
       "      <td>-158241600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-30</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>107869000</td>\n",
       "      <td>0</td>\n",
       "      <td>-157342100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-31</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-158107440</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-01</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>280058900</td>\n",
       "      <td>0</td>\n",
       "      <td>-159572400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-02</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>366040400</td>\n",
       "      <td>0</td>\n",
       "      <td>-148494150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-05</th>\n",
       "      <th>北京金鹏</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1839200</td>\n",
       "      <td>0</td>\n",
       "      <td>420757400</td>\n",
       "      <td>0</td>\n",
       "      <td>-148624200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "variety                A         B         C        CS          I        JD  \\\n",
       "date       会员简称                                                               \n",
       "2018-01-02 北京金鹏        0    425620         0  -8692460          0 -10238590   \n",
       "2018-01-03 北京金鹏        0    459200         0  -8465150          0 -10183950   \n",
       "2018-01-04 北京金鹏   -36530         0         0         0          0 -10152150   \n",
       "2018-01-05 北京金鹏        0         0         0         0          0 -10046600   \n",
       "2018-01-08 北京金鹏        0         0         0  -6805200          0  -9910560   \n",
       "2018-01-09 北京金鹏        0         0         0         0   28100000  -9877400   \n",
       "2018-01-10 北京金鹏        0         0         0  -6165400   27900000  -9848580   \n",
       "2018-01-11 北京金鹏   -36530         0         0         0   27850000  -9840720   \n",
       "2018-01-12 北京金鹏        0         0         0         0   27304500  -9838100   \n",
       "2018-01-15 北京金鹏   -36710         0         0  -7811000      53800  -9788320   \n",
       "2018-01-16 北京金鹏        0         0   -982800         0      53100  -9694000   \n",
       "2018-01-17 北京金鹏   -35980         0   -907000         0      53200  -9699240   \n",
       "2018-01-18 北京金鹏   -35920         0   -903500         0      53800  -9796180   \n",
       "2018-01-24 北京金鹏        0         0   -714400         0      52300  -8487530   \n",
       "2018-02-01 北京金鹏 -5214000         0         0         0      50700  -8154060   \n",
       "2018-02-02 北京金鹏 -5202000         0         0         0      51400  -8120760   \n",
       "2018-02-05 北京金鹏        0         0         0         0      52700  -8240640   \n",
       "2018-02-08 北京金鹏        0         0   -871680 -16639250      52500  -8258400   \n",
       "2018-02-09 北京金鹏        0         0  -1743360 -13170300      52400  -8251740   \n",
       "2018-02-12 北京金鹏        0         0  -3451370 -14189680      52400  -8398260   \n",
       "2018-02-13 北京金鹏        0         0  -3402900 -12404340      53000  -8429340   \n",
       "2018-02-22 北京金鹏        0         0  -1480920         0      54000  -8300580   \n",
       "2018-02-23 北京金鹏        0         0  -1924930         0      55000  -8495940   \n",
       "2018-02-26 北京金鹏        0         0         0         0          0  -8553660   \n",
       "2018-02-27 北京金鹏        0         0   -979560         0          0  -7750540   \n",
       "2018-02-28 北京金鹏        0         0   -911000         0          0  -7758660   \n",
       "2018-03-01 北京金鹏        0         0   -904500         0          0  -7811440   \n",
       "2018-03-05 北京金鹏        0         0         0         0          0  -7584080   \n",
       "2018-03-06 北京金鹏        0         0         0         0          0  -7618590   \n",
       "2018-03-07 北京金鹏        0         0         0         0          0  -7970050   \n",
       "2018-03-08 北京金鹏        0         0         0         0          0  -8008750   \n",
       "2018-03-09 北京金鹏        0         0         0         0          0  -8058200   \n",
       "2018-03-12 北京金鹏        0         0         0         0          0  -8728280   \n",
       "2018-03-13 北京金鹏        0         0         0         0          0  -5558310   \n",
       "2018-03-14 北京金鹏        0         0         0         0          0  -5594550   \n",
       "2018-03-15 北京金鹏        0         0         0         0          0  -6605280   \n",
       "2018-03-16 北京金鹏        0         0         0         0          0  -9644210   \n",
       "2018-03-19 北京金鹏        0         0         0         0          0 -11049840   \n",
       "2018-03-20 北京金鹏        0         0         0         0          0 -10681440   \n",
       "2018-03-21 北京金鹏        0         0         0         0          0 -10194240   \n",
       "2018-03-22 北京金鹏        0         0         0         0          0 -10250480   \n",
       "2018-03-23 北京金鹏        0         0         0         0          0 -11063160   \n",
       "2018-03-26 北京金鹏        0         0         0         0          0 -11186930   \n",
       "2018-03-27 北京金鹏        0         0         0         0          0  -6772370   \n",
       "2018-03-28 北京金鹏        0         0         0         0          0  -5242500   \n",
       "2018-03-29 北京金鹏        0         0         0         0          0  -4429100   \n",
       "2018-03-30 北京金鹏        0         0         0         0          0  -8106600   \n",
       "2018-04-02 北京金鹏        0         0         0         0          0  -8226960   \n",
       "2018-04-03 北京金鹏        0         0         0         0          0  -8278880   \n",
       "2018-04-04 北京金鹏        0  23384270         0         0          0  -8420480   \n",
       "2018-04-10 北京金鹏        0         0         0         0          0  -6822720   \n",
       "2018-04-11 北京金鹏        0         0         0         0          0  -6901840   \n",
       "2018-04-12 北京金鹏        0         0         0         0          0         0   \n",
       "2018-04-13 北京金鹏        0         0  46635660         0          0  -7390240   \n",
       "2018-04-16 北京金鹏        0         0  35554220         0          0  -7066240   \n",
       "2018-04-17 北京金鹏        0         0  34280290         0          0         0   \n",
       "2018-04-18 北京金鹏        0         0         0         0          0         0   \n",
       "2018-04-19 北京金鹏        0         0  36915120         0          0         0   \n",
       "2018-04-20 北京金鹏        0         0  37085040         0          0         0   \n",
       "2018-04-23 北京金鹏        0         0  37042560         0          0         0   \n",
       "2018-04-24 北京金鹏        0         0  36978840         0          0         0   \n",
       "2018-04-25 北京金鹏        0         0  36936360         0          0         0   \n",
       "2018-04-26 北京金鹏        0         0  36749130         0          0         0   \n",
       "2018-04-27 北京金鹏        0         0  36423960         0          0         0   \n",
       "2018-05-08 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-09 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-10 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-11 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-14 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-15 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-16 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-17 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-18 北京金鹏        0         0         0         0  -61103700         0   \n",
       "2018-05-21 北京金鹏        0         0  18023910         0          0         0   \n",
       "2018-05-22 北京金鹏        0         0         0         0  -58157400         0   \n",
       "2018-05-23 北京金鹏        0         0         0         0          0         0   \n",
       "2018-05-24 北京金鹏        0         0 -72394520         0          0         0   \n",
       "2018-05-25 北京金鹏        0         0 -71993220         0          0         0   \n",
       "2018-05-28 北京金鹏        0         0 -76940600         0          0         0   \n",
       "2018-05-29 北京金鹏        0         0 -79523640         0          0         0   \n",
       "2018-05-30 北京金鹏        0         0 -78996120         0          0         0   \n",
       "2018-05-31 北京金鹏        0         0 -65015200         0          0         0   \n",
       "2018-06-01 北京金鹏        0         0  14421090         0          0         0   \n",
       "2018-06-04 北京金鹏        0         0  13554000         0          0         0   \n",
       "2018-06-05 北京金鹏        0         0   8792040         0          0         0   \n",
       "2018-06-06 北京金鹏        0         0   5871200         0          0         0   \n",
       "2018-06-07 北京金鹏        0         0    519970         0          0         0   \n",
       "2018-06-08 北京金鹏        0         0   8976240         0          0         0   \n",
       "2018-06-11 北京金鹏        0         0   9237330         0          0         0   \n",
       "2018-06-12 北京金鹏        0         0 -58536960         0          0         0   \n",
       "2018-06-13 北京金鹏        0         0    195470         0          0         0   \n",
       "2018-06-14 北京金鹏        0         0 -61646220         0          0         0   \n",
       "2018-06-15 北京金鹏        0         0 -63189280         0   14190000         0   \n",
       "2018-06-19 北京金鹏        0         0 -63100080         0          0         0   \n",
       "2018-06-20 北京金鹏        0         0 -63366720         0          0         0   \n",
       "2018-06-21 北京金鹏        0         0 -67038840         0          0         0   \n",
       "2018-06-22 北京金鹏        0         0 -67890660         0          0         0   \n",
       "2018-06-25 北京金鹏        0         0 -62881280         0          0         0   \n",
       "2018-06-26 北京金鹏        0         0 -62764850         0          0         0   \n",
       "2018-06-27 北京金鹏        0         0 -61909650         0          0         0   \n",
       "2018-06-28 北京金鹏        0         0 -61743200         0          0         0   \n",
       "2018-06-29 北京金鹏        0         0 -62143520         0          0         0   \n",
       "2018-07-02 北京金鹏        0         0 -62052720         0          0         0   \n",
       "2018-07-03 北京金鹏        0         0 -61980080         0          0         0   \n",
       "2018-07-04 北京金鹏        0         0 -62014210         0          0         0   \n",
       "2018-07-05 北京金鹏        0         0 -61604650         0          0         0   \n",
       "2018-07-06 北京金鹏        0         0 -61877690         0          0         0   \n",
       "2018-07-09 北京金鹏        0         0 -63931200         0          0         0   \n",
       "2018-07-10 北京金鹏        0         0 -64699220         0          0         0   \n",
       "2018-07-11 北京金鹏        0         0         0         0          0         0   \n",
       "2018-07-12 北京金鹏        0         0         0         0          0         0   \n",
       "2018-07-13 北京金鹏        0  17869620         0         0          0         0   \n",
       "2018-07-16 北京金鹏        0  17917230         0         0          0         0   \n",
       "2018-07-17 北京金鹏        0         0         0         0          0         0   \n",
       "2018-07-18 北京金鹏        0         0         0         0          0         0   \n",
       "2018-07-19 北京金鹏        0    -67960         0         0          0         0   \n",
       "2018-07-20 北京金鹏        0         0         0         0          0         0   \n",
       "2018-07-23 北京金鹏        0     34590         0         0          0         0   \n",
       "2018-07-24 北京金鹏        0     34400         0         0          0         0   \n",
       "2018-07-25 北京金鹏        0     34870  36793900         0          0         0   \n",
       "2018-07-26 北京金鹏        0     34970         0         0          0         0   \n",
       "2018-07-27 北京金鹏        0     34530         0         0          0         0   \n",
       "2018-07-30 北京金鹏        0     34590         0         0          0         0   \n",
       "2018-07-31 北京金鹏        0     34150  37260630         0          0         0   \n",
       "2018-08-01 北京金鹏        0     34340  37161640         0          0         0   \n",
       "2018-08-02 北京金鹏        0     34420  37181760         0          0         0   \n",
       "2018-08-03 北京金鹏        0     33860  37019070         0          0         0   \n",
       "2018-08-06 北京金鹏        0     34300  36666900         0  211327200         0   \n",
       "2018-08-07 北京金鹏        0     34590  36572650         0  257186300         0   \n",
       "2018-08-08 北京金鹏        0         0         0         0  290308200         0   \n",
       "2018-08-09 北京金鹏        0         0         0         0  293025600         0   \n",
       "2018-08-10 北京金鹏        0         0  21071160         0  258975600         0   \n",
       "2018-08-13 北京金鹏        0         0         0         0  155565300         0   \n",
       "2018-08-14 北京金鹏        0         0         0         0  443270100         0   \n",
       "2018-08-15 北京金鹏        0         0         0         0  416282800         0   \n",
       "2018-08-16 北京金鹏        0         0         0         0  408883800         0   \n",
       "2018-08-17 北京金鹏        0         0         0         0  613272000         0   \n",
       "2018-08-20 北京金鹏        0         0         0         0  767547300         0   \n",
       "2018-08-21 北京金鹏        0         0         0         0  826116200         0   \n",
       "2018-08-22 北京金鹏        0         0         0         0  787979500         0   \n",
       "2018-08-23 北京金鹏        0         0         0         0  791180200         0   \n",
       "2018-08-24 北京金鹏        0         0         0         0  795564000         0   \n",
       "2018-08-27 北京金鹏        0         0         0         0  561579600         0   \n",
       "2018-08-28 北京金鹏        0         0         0         0  587750800         0   \n",
       "2018-08-29 北京金鹏        0         0         0         0  586771900         0   \n",
       "2018-08-30 北京金鹏        0         0         0         0  442126000         0   \n",
       "2018-08-31 北京金鹏        0         0         0         0  392850000         0   \n",
       "2018-09-03 北京金鹏        0         0         0         0  390830000         0   \n",
       "2018-09-04 北京金鹏        0         0         0         0  394743200         0   \n",
       "2018-09-05 北京金鹏        0         0         0         0  393690800         0   \n",
       "2018-09-06 北京金鹏        0         0         0         0  405465400         0   \n",
       "2018-09-07 北京金鹏        0         0         0         0  402682800         0   \n",
       "2018-09-10 北京金鹏        0         0         0         0  405253800         0   \n",
       "2018-09-11 北京金鹏        0         0         0         0  399897600         0   \n",
       "2018-09-12 北京金鹏        0         0         0         0  398323200         0   \n",
       "2018-09-13 北京金鹏        0         0         0         0  407731800         0   \n",
       "2018-09-14 北京金鹏        0         0         0         0  406361100         0   \n",
       "2018-09-17 北京金鹏        0         0         0         0  405900000         0   \n",
       "2018-09-18 北京金鹏        0         0         0         0  410011800         0   \n",
       "2018-09-19 北京金鹏        0         0         0         0  407181600         0   \n",
       "2018-09-20 北京金鹏        0         0         0         0  404307000         0   \n",
       "2018-09-21 北京金鹏        0         0         0         0  404106600         0   \n",
       "2018-09-25 北京金鹏        0         0         0         0  402470600         0   \n",
       "2018-09-26 北京金鹏        0         0         0         0  407450000         0   \n",
       "2018-09-27 北京金鹏        0         0         0         0  422055000         0   \n",
       "2018-09-28 北京金鹏        0         0         0         0  399379200         0   \n",
       "2018-10-08 北京金鹏        0         0         0         0  402094200         0   \n",
       "2018-10-09 北京金鹏        0         0         0         0  411475600         0   \n",
       "2018-10-10 北京金鹏        0         0         0         0  467980500         0   \n",
       "2018-10-11 北京金鹏        0         0         0         0  467200000         0   \n",
       "2018-10-12 北京金鹏        0         0         0         0  470334000         0   \n",
       "2018-10-15 北京金鹏        0         0         0         0  542742000         0   \n",
       "2018-10-16 北京金鹏        0         0         0         0  513988200         0   \n",
       "2018-10-17 北京金鹏        0         0         0         0  527236300         0   \n",
       "2018-10-18 北京金鹏        0         0         0         0  525427100         0   \n",
       "2018-10-19 北京金鹏        0         0         0         0  602723700         0   \n",
       "2018-10-22 北京金鹏        0         0         0         0  619944400         0   \n",
       "2018-10-23 北京金鹏        0         0         0         0  610914900         0   \n",
       "2018-10-24 北京金鹏        0         0         0         0  547091000         0   \n",
       "2018-10-25 北京金鹏        0         0         0         0  500133200         0   \n",
       "2018-10-26 北京金鹏        0         0         0         0  553969200         0   \n",
       "2018-10-29 北京金鹏        0         0         0         0  553593300         0   \n",
       "2018-10-30 北京金鹏        0         0         0         0  107869000         0   \n",
       "2018-10-31 北京金鹏        0         0         0         0          0         0   \n",
       "2018-11-01 北京金鹏        0         0         0         0  280058900         0   \n",
       "2018-11-02 北京金鹏        0         0         0         0  366040400         0   \n",
       "2018-11-05 北京金鹏        0         0   1839200         0  420757400         0   \n",
       "\n",
       "variety                  M          P          Y  \n",
       "date       会员简称                                   \n",
       "2018-01-02 北京金鹏          0          0          0  \n",
       "2018-01-03 北京金鹏          0          0          0  \n",
       "2018-01-04 北京金鹏          0          0          0  \n",
       "2018-01-05 北京金鹏          0          0          0  \n",
       "2018-01-08 北京金鹏          0          0          0  \n",
       "2018-01-09 北京金鹏          0          0          0  \n",
       "2018-01-10 北京金鹏          0          0          0  \n",
       "2018-01-11 北京金鹏          0          0          0  \n",
       "2018-01-12 北京金鹏          0          0          0  \n",
       "2018-01-15 北京金鹏          0          0          0  \n",
       "2018-01-16 北京金鹏          0          0          0  \n",
       "2018-01-17 北京金鹏          0          0          0  \n",
       "2018-01-18 北京金鹏          0          0          0  \n",
       "2018-01-24 北京金鹏          0          0          0  \n",
       "2018-02-01 北京金鹏          0          0          0  \n",
       "2018-02-02 北京金鹏          0          0          0  \n",
       "2018-02-05 北京金鹏          0          0          0  \n",
       "2018-02-08 北京金鹏          0          0   -2829500  \n",
       "2018-02-09 北京金鹏          0          0   -2820000  \n",
       "2018-02-12 北京金鹏          0          0          0  \n",
       "2018-02-13 北京金鹏          0          0   -2836500  \n",
       "2018-02-22 北京金鹏      29480          0   -2845000  \n",
       "2018-02-23 北京金鹏      29470          0          0  \n",
       "2018-02-26 北京金鹏          0          0          0  \n",
       "2018-02-27 北京金鹏      29570          0          0  \n",
       "2018-02-28 北京金鹏      29940          0          0  \n",
       "2018-03-01 北京金鹏      30380          0          0  \n",
       "2018-03-05 北京金鹏      31000          0          0  \n",
       "2018-03-06 北京金鹏          0          0          0  \n",
       "2018-03-07 北京金鹏          0          0          0  \n",
       "2018-03-08 北京金鹏          0          0          0  \n",
       "2018-03-09 北京金鹏          0          0          0  \n",
       "2018-03-12 北京金鹏          0          0          0  \n",
       "2018-03-13 北京金鹏          0          0          0  \n",
       "2018-03-14 北京金鹏          0          0          0  \n",
       "2018-03-15 北京金鹏     211120          0          0  \n",
       "2018-03-16 北京金鹏     213430          0          0  \n",
       "2018-03-19 北京金鹏     210420          0          0  \n",
       "2018-03-20 北京金鹏     239120          0          0  \n",
       "2018-03-21 北京金鹏     210070          0          0  \n",
       "2018-03-22 北京金鹏     210280          0          0  \n",
       "2018-03-23 北京金鹏     976000          0          0  \n",
       "2018-03-26 北京金鹏    1019370          0          0  \n",
       "2018-03-27 北京金鹏    1100880          0          0  \n",
       "2018-03-28 北京金鹏    1248450          0          0  \n",
       "2018-03-29 北京金鹏    1298170          0          0  \n",
       "2018-03-30 北京金鹏    1009280          0          0  \n",
       "2018-04-02 北京金鹏    1009920          0          0  \n",
       "2018-04-03 北京金鹏    1010560          0          0  \n",
       "2018-04-04 北京金鹏     932930          0          0  \n",
       "2018-04-10 北京金鹏    1006880          0          0  \n",
       "2018-04-11 北京金鹏   49955940          0          0  \n",
       "2018-04-12 北京金鹏   48658080          0          0  \n",
       "2018-04-13 北京金鹏   48854770          0          0  \n",
       "2018-04-16 北京金鹏   48446260          0          0  \n",
       "2018-04-17 北京金鹏      65280          0          0  \n",
       "2018-04-18 北京金鹏      64600          0          0  \n",
       "2018-04-19 北京金鹏      64240          0          0  \n",
       "2018-04-20 北京金鹏      64600          0          0  \n",
       "2018-04-23 北京金鹏      64060          0          0  \n",
       "2018-04-24 北京金鹏      63760          0          0  \n",
       "2018-04-25 北京金鹏      64000          0          0  \n",
       "2018-04-26 北京金鹏      63520          0          0  \n",
       "2018-04-27 北京金鹏      63400          0          0  \n",
       "2018-05-08 北京金鹏          0          0          0  \n",
       "2018-05-09 北京金鹏          0          0          0  \n",
       "2018-05-10 北京金鹏          0          0          0  \n",
       "2018-05-11 北京金鹏          0          0          0  \n",
       "2018-05-14 北京金鹏          0          0          0  \n",
       "2018-05-15 北京金鹏          0          0          0  \n",
       "2018-05-16 北京金鹏          0          0          0  \n",
       "2018-05-17 北京金鹏          0          0          0  \n",
       "2018-05-18 北京金鹏          0          0          0  \n",
       "2018-05-21 北京金鹏          0          0          0  \n",
       "2018-05-22 北京金鹏          0          0          0  \n",
       "2018-05-23 北京金鹏 -140577000          0  -64097000  \n",
       "2018-05-24 北京金鹏 -143444000          0          0  \n",
       "2018-05-25 北京金鹏 -142504000          0          0  \n",
       "2018-05-28 北京金鹏 -142974000          0          0  \n",
       "2018-05-29 北京金鹏 -144948000          0          0  \n",
       "2018-05-30 北京金鹏 -143773000          0          0  \n",
       "2018-05-31 北京金鹏 -142598000          0          0  \n",
       "2018-06-01 北京金鹏 -142974000          0          0  \n",
       "2018-06-04 北京金鹏 -143820000          0          0  \n",
       "2018-06-05 北京金鹏 -142410000          0          0  \n",
       "2018-06-06 北京金鹏 -141940000          0          0  \n",
       "2018-06-07 北京金鹏 -141094000          0          0  \n",
       "2018-06-08 北京金鹏 -137737600          0          0  \n",
       "2018-06-11 北京金鹏 -137851000          0          0  \n",
       "2018-06-12 北京金鹏 -137945000          0          0  \n",
       "2018-06-13 北京金鹏 -139496000          0          0  \n",
       "2018-06-14 北京金鹏 -140154000          0          0  \n",
       "2018-06-15 北京金鹏 -139590000          0          0  \n",
       "2018-06-19 北京金鹏 -144525000          0          0  \n",
       "2018-06-20 北京金鹏 -143726000          0          0  \n",
       "2018-06-21 北京金鹏 -142128000          0          0  \n",
       "2018-06-22 北京金鹏 -140624000          0          0  \n",
       "2018-06-25 北京金鹏 -142034000          0          0  \n",
       "2018-06-26 北京金鹏 -144384000          0          0  \n",
       "2018-06-27 北京金鹏 -147298000          0          0  \n",
       "2018-06-28 北京金鹏 -147298000          0          0  \n",
       "2018-06-29 北京金鹏 -148426000          0          0  \n",
       "2018-07-02 北京金鹏 -150165000          0          0  \n",
       "2018-07-03 北京金鹏 -148473000          0          0  \n",
       "2018-07-04 北京金鹏 -147533000          0          0  \n",
       "2018-07-05 北京金鹏 -147815000          0          0  \n",
       "2018-07-06 北京金鹏 -146546000          0          0  \n",
       "2018-07-09 北京金鹏 -146640000          0          0  \n",
       "2018-07-10 北京金鹏 -148025000          0          0  \n",
       "2018-07-11 北京金鹏 -148311500          0          0  \n",
       "2018-07-12 北京金鹏 -149140750          0          0  \n",
       "2018-07-13 北京金鹏 -147596750          0          0  \n",
       "2018-07-16 北京金鹏 -148031000          0          0  \n",
       "2018-07-17 北京金鹏 -149382000          0          0  \n",
       "2018-07-18 北京金鹏 -147452000          0  231935040  \n",
       "2018-07-19 北京金鹏 -147895130          0  225791900  \n",
       "2018-07-20 北京金鹏 -148846530          0  227600100  \n",
       "2018-07-23 北京金鹏 -195781530          0  229073740  \n",
       "2018-07-24 北京金鹏 -200007000          0  234666460  \n",
       "2018-07-25 北京金鹏 -204081020          0  231469410  \n",
       "2018-07-26 北京金鹏 -198922230          0  354545100  \n",
       "2018-07-27 北京金鹏 -256078800          0  439384500  \n",
       "2018-07-30 北京金鹏 -279818100          0  461909280  \n",
       "2018-07-31 北京金鹏 -280518740          0  462099880  \n",
       "2018-08-01 北京金鹏 -277130450 -132851480  500488800  \n",
       "2018-08-02 北京金鹏 -281654250          0  509504040  \n",
       "2018-08-03 北京金鹏 -280732760          0  507191700  \n",
       "2018-08-06 北京金鹏 -281565540          0  505818720  \n",
       "2018-08-07 北京金鹏 -290368000          0  509745600  \n",
       "2018-08-08 北京金鹏 -295173450          0  523350720  \n",
       "2018-08-09 北京金鹏 -295526120          0  539427480  \n",
       "2018-08-10 北京金鹏 -296175360          0  551308800  \n",
       "2018-08-13 北京金鹏 -288471700          0  552483150  \n",
       "2018-08-14 北京金鹏 -289267200          0  558017200  \n",
       "2018-08-15 北京金鹏 -295061080          0  562629450  \n",
       "2018-08-16 北京金鹏 -281546400          0  551248700  \n",
       "2018-08-17 北京金鹏 -281559790          0  548551500  \n",
       "2018-08-20 北京金鹏 -281265780          0  537142400  \n",
       "2018-08-21 北京金鹏 -278529030          0  537889040  \n",
       "2018-08-22 北京金鹏 -277684470          0  523514800  \n",
       "2018-08-23 北京金鹏 -272229000          0  522770600  \n",
       "2018-08-24 北京金鹏 -271260250          0  517844840  \n",
       "2018-08-27 北京金鹏 -263290320          0  515843600  \n",
       "2018-08-28 北京金鹏 -264640200          0  517462400  \n",
       "2018-08-29 北京金鹏 -265750840          0  492486380  \n",
       "2018-08-30 北京金鹏 -271257600          0  491701540  \n",
       "2018-08-31 北京金鹏 -271821330          0  488268440  \n",
       "2018-09-03 北京金鹏 -275798820          0  493710600  \n",
       "2018-09-04 北京金鹏 -275709910          0  504084060  \n",
       "2018-09-05 北京金鹏 -273384160          0  501106760  \n",
       "2018-09-06 北京金鹏 -274208380          0  502589400  \n",
       "2018-09-07 北京金鹏 -274443000          0  505790420  \n",
       "2018-09-10 北京金鹏 -246599840          0  526669170  \n",
       "2018-09-11 北京金鹏 -247727570          0  526457000  \n",
       "2018-09-12 北京金鹏 -183615530          0  525325500  \n",
       "2018-09-13 北京金鹏          0          0          0  \n",
       "2018-09-14 北京金鹏 -152439660          0          0  \n",
       "2018-09-17 北京金鹏 -153566240          0          0  \n",
       "2018-09-18 北京金鹏          0  301787640          0  \n",
       "2018-09-19 北京金鹏 -155831100          0          0  \n",
       "2018-09-20 北京金鹏 -154641280          0          0  \n",
       "2018-09-21 北京金鹏 -154005600          0          0  \n",
       "2018-09-25 北京金鹏          0          0          0  \n",
       "2018-09-26 北京金鹏          0          0          0  \n",
       "2018-09-27 北京金鹏          0          0          0  \n",
       "2018-09-28 北京金鹏          0          0          0  \n",
       "2018-10-08 北京金鹏          0          0          0  \n",
       "2018-10-09 北京金鹏          0          0          0  \n",
       "2018-10-10 北京金鹏 -163667160          0          0  \n",
       "2018-10-11 北京金鹏 -164819900          0          0  \n",
       "2018-10-12 北京金鹏 -163198800          0          0  \n",
       "2018-10-15 北京金鹏 -162337600          0          0  \n",
       "2018-10-16 北京金鹏 -164388980          0          0  \n",
       "2018-10-17 北京金鹏 -164485650          0          0  \n",
       "2018-10-18 北京金鹏 -163692240          0          0  \n",
       "2018-10-19 北京金鹏 -160611450          0          0  \n",
       "2018-10-22 北京金鹏 -159364330          0          0  \n",
       "2018-10-23 北京金鹏 -159123380          0          0  \n",
       "2018-10-24 北京金鹏 -158669840          0          0  \n",
       "2018-10-25 北京金鹏 -161634980          0          0  \n",
       "2018-10-26 北京金鹏 -161710120          0          0  \n",
       "2018-10-29 北京金鹏 -158241600          0          0  \n",
       "2018-10-30 北京金鹏 -157342100          0          0  \n",
       "2018-10-31 北京金鹏 -158107440          0          0  \n",
       "2018-11-01 北京金鹏 -159572400          0          0  \n",
       "2018-11-02 北京金鹏 -148494150          0          0  \n",
       "2018-11-05 北京金鹏 -148624200          0          0  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymongo\n",
    "import pandas as pd\n",
    "import matplotlib as plt\n",
    "from pandas import Series,DataFrame\n",
    "pd.set_option('display.width', None)  # 设置字符显示宽度\n",
    "pd.set_option('display.max_rows', None)  # 设置显示最大行\n",
    "pd.set_option('display.max_columns', None)  # 设置显示最大行\n",
    "#二行即可搞定画图中文乱码\n",
    "plt.rcParams['font.sans-serif']=['SimHei'] #用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus']=False #用来正常显示负号\n",
    "from IPython.core.display import display, HTML\n",
    "display(HTML(\"<style>.container { width:100% !important; }</style>\"))\n",
    "\n",
    "#连接数据库\n",
    "client = pymongo.MongoClient('localhost',27017)\n",
    "futures = client.futures\n",
    "\n",
    "market = futures.market\n",
    "unit = futures.unit\n",
    "position = futures.position\n",
    "\n",
    "#加载数据\n",
    "market = DataFrame(list(market.find()))\n",
    "unit = DataFrame(list(unit.find()))\n",
    "position = DataFrame(list(position.find()))\n",
    "\n",
    "#大写字母\n",
    "position['variety']=position['variety'].str.upper()\n",
    "\n",
    "#删除/选取某行含有特殊数值的列\n",
    "position=position.set_index('名次')\n",
    "\n",
    "#选择需要显示的字段\n",
    "data1=market[['date','variety','set_close']]\n",
    "\n",
    "data2=unit[[ 'variety','unit']]\n",
    "position=position[['date','variety','symbol','持买仓量期货公司','持买仓量', '持买仓量增减','持卖仓量期货公司','持卖仓量', '持卖仓量增减']]\n",
    "\n",
    "#查询会员\n",
    "members='北京金鹏'\n",
    "data3=position[(position['持买仓量期货公司'] == members)]\n",
    "#汇总合约\n",
    "data3=data3[['date','variety','持买仓量期货公司','持买仓量']]\n",
    "data3=data3.groupby(['date','variety','持买仓量期货公司'])[['持买仓量']].sum()\n",
    "data4=position[(position['持卖仓量期货公司'] == members)]\n",
    "data4=data4[['date','variety','持卖仓量期货公司','持卖仓量']]\n",
    "data4=data4.groupby(['date','variety','持卖仓量期货公司'])[['持卖仓量']].sum()\n",
    "print(data3.head())\n",
    "print(data4.head())\n",
    "\n",
    "#并集\n",
    "data5=pd.merge(data3,data4, on=['date','variety'],how='outer')\n",
    "data5['会员简称']=data5.apply(lambda x: members,axis=1)\n",
    "\n",
    "#nan缺失值填充fillna()为0\n",
    "data5=data5.fillna(0)\n",
    "data5['净持仓']=data5.apply(lambda x: x['持买仓量']-x['持卖仓量'],axis=1)\n",
    "#选择需要显示的字段\n",
    "data5=data5[['会员简称','持买仓量','持卖仓量','净持仓']]\n",
    "data5=data5.reset_index(['variety','date'])\n",
    "print(data5.head())\n",
    "netpostion=data5.set_index('date')\n",
    "\n",
    "netpostion=data5.pivot_table('净持仓',index='date',columns='variety',fill_value=0)\n",
    "\n",
    "#合约价值\n",
    "contractValue=pd.merge(data1,data2,how='left',sort=False).drop_duplicates()\n",
    "contractValue['contractValue'] = contractValue.apply(lambda x: x['set_close']*x['unit'],axis=1)\n",
    "contractValue=contractValue[['date','variety','contractValue']]\n",
    "#值替换replace()\n",
    "contractValue=contractValue.replace(['TA'],'PTA')\n",
    "print(contractValue.head())\n",
    "sz=pd.merge(data5,contractValue,on=['date','variety'],how='left')\n",
    "\n",
    "#净持仓价值\n",
    "sz['净持仓价值']=sz.apply(lambda x: x['净持仓']*x['contractValue'],axis=1)\n",
    "sz=sz[['date','variety','会员简称','净持仓价值']]\n",
    "sz=sz.sort_values(by='净持仓价值')\n",
    "sz=sz.pivot_table('净持仓价值',index=['date','会员简称'],columns='variety',fill_value=0)\n",
    "sz=sz.copy()\n",
    "sz\n",
    "# sz['黑色板块']=sz[['I']].sum(axis=1)\n",
    "# sz['化工板块']=sz[['RU','MA','V','L','PP','BU','PTA']].sum(axis=1)\n",
    "# sz['油脂板块']=sz[['Y','P','OI']].sum(axis=1)\n",
    "# sz['有色板块']=sz[['CU','AL','ZN','NI','PB']].sum(axis=1)\n",
    "# sz['黑色板块']=sz[['RB','HC','ZC','J','JM','I']].sum(axis=1)\n",
    "# sz['黄金白银']=sz[['AU','AG']].sum(axis=1)\n",
    "# sz['工业品']=sz[['CU','AL','ZN','NI','PB','RB','FG','RU','L','V','PTA','MA','PP','JM','J','ZC','I','BU','HC','SM','SF','FU']].sum(axis=1)\n",
    "# sz['农产品']=sz[['A','C','M','RM','Y','P','OI','CF','SR','JD','CS','AP']].sum(axis=1)\n",
    "# sz['商品板块']=sz.sum(axis=1)\n",
    "# sz\n",
    "\n",
    "\n",
    "# chemical=sz.copy()\n",
    "# chemical=chemical[['RU','MA','V','L','PP','BU','PTA','商品板块','工业品','化工板块']]\n",
    "# chemical['max']=chemical[['RU','MA','V','L','PP','BU','PTA']].idxmax(axis=1)\n",
    "# chemical['min']=chemical[['RU','MA','V','L','PP','BU']].idxmin(axis=1)\n",
    "# chemical['2018-10-1':]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>variety</th>\n",
       "      <th>RB</th>\n",
       "      <th>HC</th>\n",
       "      <th>J</th>\n",
       "      <th>JM</th>\n",
       "      <th>I</th>\n",
       "      <th>黑色板块</th>\n",
       "      <th>max</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th>会员简称</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2018-01-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>5883000</td>\n",
       "      <td>20150000</td>\n",
       "      <td>0</td>\n",
       "      <td>-322324800</td>\n",
       "      <td>-296291800</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-03</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-843277220</td>\n",
       "      <td>6948000</td>\n",
       "      <td>20150000</td>\n",
       "      <td>0</td>\n",
       "      <td>-328889600</td>\n",
       "      <td>-1145068820</td>\n",
       "      <td>J</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-919657470</td>\n",
       "      <td>6969600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-270848400</td>\n",
       "      <td>-1183536270</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-929133280</td>\n",
       "      <td>6908400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-255162600</td>\n",
       "      <td>-1177387480</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-727558320</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-240303200</td>\n",
       "      <td>-967861520</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-725003820</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-243177400</td>\n",
       "      <td>-968181220</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-733012360</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-246189600</td>\n",
       "      <td>-979201960</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-284627000</td>\n",
       "      <td>-284627000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-219907500</td>\n",
       "      <td>-219907500</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-211810600</td>\n",
       "      <td>-211810600</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-747756240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-208417500</td>\n",
       "      <td>-956173740</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-756481580</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-208756800</td>\n",
       "      <td>-965238380</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-211326400</td>\n",
       "      <td>-211326400</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-01-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-205643600</td>\n",
       "      <td>-205643600</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-01</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-940098960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-239506800</td>\n",
       "      <td>-1179605760</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-990081600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-241785600</td>\n",
       "      <td>-1231867200</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-986820340</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-274303500</td>\n",
       "      <td>-1261123840</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-835491610</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-299460000</td>\n",
       "      <td>-1134951610</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-779687040</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-220394400</td>\n",
       "      <td>-1000081440</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-780627300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-220499200</td>\n",
       "      <td>-1001126500</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-775360950</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-222600000</td>\n",
       "      <td>-997960950</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-226962000</td>\n",
       "      <td>-226962000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-328680000</td>\n",
       "      <td>-328680000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-913425630</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-359370000</td>\n",
       "      <td>-1272795630</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-831192030</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-358118000</td>\n",
       "      <td>-1189310030</td>\n",
       "      <td>HC</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-02-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-15719200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-321721600</td>\n",
       "      <td>-337440800</td>\n",
       "      <td>HC</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-01</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-16928410</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-329398000</td>\n",
       "      <td>-346326410</td>\n",
       "      <td>HC</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>855492800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-229135800</td>\n",
       "      <td>626357000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-06</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>854712000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-115153200</td>\n",
       "      <td>739558800</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-07</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>840873600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>840873600</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>815076010</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>815076010</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>804824000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>804824000</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>805687210</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>805687210</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>807941260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>807941260</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-14</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>792937860</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>792937860</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>905475780</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>905475780</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>901674630</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>901674630</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>883370880</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>883370880</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>697350390</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>697350390</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-21</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>691616100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>691616100</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>692364120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>692364120</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>52648960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52648960</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>615044020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>615044020</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>544270410</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>967519000</td>\n",
       "      <td>1511789410</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>868507000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1003671900</td>\n",
       "      <td>1872178900</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-29</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>393772300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1014917600</td>\n",
       "      <td>1408689900</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-03-30</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>97529040</td>\n",
       "      <td>0</td>\n",
       "      <td>76415760</td>\n",
       "      <td>1018870800</td>\n",
       "      <td>1192815600</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>96646240</td>\n",
       "      <td>0</td>\n",
       "      <td>76008360</td>\n",
       "      <td>1026175600</td>\n",
       "      <td>1198830200</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-03</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>72026960</td>\n",
       "      <td>0</td>\n",
       "      <td>76083840</td>\n",
       "      <td>695905100</td>\n",
       "      <td>844015900</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>71779000</td>\n",
       "      <td>0</td>\n",
       "      <td>76431300</td>\n",
       "      <td>378404400</td>\n",
       "      <td>526614700</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>250381320</td>\n",
       "      <td>75119760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>325501080</td>\n",
       "      <td>RB</td>\n",
       "      <td>J</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>227062920</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>89670360</td>\n",
       "      <td>488160000</td>\n",
       "      <td>804893280</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>658608200</td>\n",
       "      <td>658608200</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>35747850</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1212556800</td>\n",
       "      <td>1248304650</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>35917430</td>\n",
       "      <td>0</td>\n",
       "      <td>35535000</td>\n",
       "      <td>577610800</td>\n",
       "      <td>649063230</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>35090040</td>\n",
       "      <td>0</td>\n",
       "      <td>34360800</td>\n",
       "      <td>557612000</td>\n",
       "      <td>627062840</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>35500860</td>\n",
       "      <td>0</td>\n",
       "      <td>34904520</td>\n",
       "      <td>1188337800</td>\n",
       "      <td>1258743180</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>36122100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1222995200</td>\n",
       "      <td>1259117300</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14842800</td>\n",
       "      <td>1292455800</td>\n",
       "      <td>1307298600</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13632000</td>\n",
       "      <td>1254144000</td>\n",
       "      <td>1267776000</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1103225200</td>\n",
       "      <td>1103225200</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1066130800</td>\n",
       "      <td>1066130800</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1069616800</td>\n",
       "      <td>1069616800</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1065454500</td>\n",
       "      <td>1065454500</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-04-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>276092000</td>\n",
       "      <td>276092000</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>73932000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>261075300</td>\n",
       "      <td>335007300</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-07</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>109796200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>259403900</td>\n",
       "      <td>369200100</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>109752930</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>257355000</td>\n",
       "      <td>367107930</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>109501920</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>127661800</td>\n",
       "      <td>237163720</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>128153110</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>121986900</td>\n",
       "      <td>250140010</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>129184000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>107166800</td>\n",
       "      <td>236350800</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-14</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>128353100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4276800</td>\n",
       "      <td>132629900</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>91189600</td>\n",
       "      <td>0</td>\n",
       "      <td>472514900</td>\n",
       "      <td>0</td>\n",
       "      <td>-380472400</td>\n",
       "      <td>183232100</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>148532400</td>\n",
       "      <td>0</td>\n",
       "      <td>406232400</td>\n",
       "      <td>0</td>\n",
       "      <td>-424434400</td>\n",
       "      <td>130330400</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>148613300</td>\n",
       "      <td>0</td>\n",
       "      <td>473639400</td>\n",
       "      <td>0</td>\n",
       "      <td>-371670200</td>\n",
       "      <td>250582500</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>109070080</td>\n",
       "      <td>0</td>\n",
       "      <td>507349700</td>\n",
       "      <td>0</td>\n",
       "      <td>-368387100</td>\n",
       "      <td>248032680</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-21</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>107735040</td>\n",
       "      <td>154920080</td>\n",
       "      <td>565401400</td>\n",
       "      <td>0</td>\n",
       "      <td>-356816000</td>\n",
       "      <td>471240520</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>108431520</td>\n",
       "      <td>152988180</td>\n",
       "      <td>573357700</td>\n",
       "      <td>0</td>\n",
       "      <td>-386671800</td>\n",
       "      <td>448105600</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>106701750</td>\n",
       "      <td>0</td>\n",
       "      <td>499740900</td>\n",
       "      <td>0</td>\n",
       "      <td>-298389000</td>\n",
       "      <td>308053650</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>107733580</td>\n",
       "      <td>0</td>\n",
       "      <td>466889500</td>\n",
       "      <td>0</td>\n",
       "      <td>-200146000</td>\n",
       "      <td>374477080</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-197009700</td>\n",
       "      <td>-197009700</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-197508000</td>\n",
       "      <td>-197508000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-29</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-187653900</td>\n",
       "      <td>-187653900</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-30</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-193375000</td>\n",
       "      <td>-193375000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-05-31</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-777730800</td>\n",
       "      <td>-777730800</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-01</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-199435500</td>\n",
       "      <td>-199435500</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-182773500</td>\n",
       "      <td>-182773500</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-892669600</td>\n",
       "      <td>-892669600</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-06</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-934857700</td>\n",
       "      <td>-934857700</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-07</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-740241700</td>\n",
       "      <td>-740241700</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-697546500</td>\n",
       "      <td>-697546500</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-646704100</td>\n",
       "      <td>-646704100</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-703091200</td>\n",
       "      <td>-703091200</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-683897000</td>\n",
       "      <td>-683897000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-14</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-691432800</td>\n",
       "      <td>-691432800</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-677998200</td>\n",
       "      <td>-677998200</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>226080000</td>\n",
       "      <td>226080000</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-183636150</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-306092100</td>\n",
       "      <td>-489728250</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-21</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-297526560</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>228583800</td>\n",
       "      <td>-68942760</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-296602020</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-306705600</td>\n",
       "      <td>-603307620</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-246425410</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-316969800</td>\n",
       "      <td>-563395210</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-274150800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-310233000</td>\n",
       "      <td>-584383800</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-282063600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-226996400</td>\n",
       "      <td>-509060000</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-189279360</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-297338900</td>\n",
       "      <td>-486618260</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-06-29</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-172025100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-304071000</td>\n",
       "      <td>-476096100</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-1036323120</td>\n",
       "      <td>-174950930</td>\n",
       "      <td>61094600</td>\n",
       "      <td>0</td>\n",
       "      <td>122556100</td>\n",
       "      <td>-1027623350</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-03</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-1048153760</td>\n",
       "      <td>-184010040</td>\n",
       "      <td>61396600</td>\n",
       "      <td>0</td>\n",
       "      <td>123192000</td>\n",
       "      <td>-1047575200</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-1082871390</td>\n",
       "      <td>-171479710</td>\n",
       "      <td>61668400</td>\n",
       "      <td>0</td>\n",
       "      <td>131716200</td>\n",
       "      <td>-1060966500</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-1074810420</td>\n",
       "      <td>-178091210</td>\n",
       "      <td>60702000</td>\n",
       "      <td>0</td>\n",
       "      <td>217714800</td>\n",
       "      <td>-974484830</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-06</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>-996630550</td>\n",
       "      <td>-177899260</td>\n",
       "      <td>60641600</td>\n",
       "      <td>0</td>\n",
       "      <td>224910000</td>\n",
       "      <td>-888978210</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-178821900</td>\n",
       "      <td>61275800</td>\n",
       "      <td>0</td>\n",
       "      <td>138276600</td>\n",
       "      <td>20730500</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-174787400</td>\n",
       "      <td>61094600</td>\n",
       "      <td>0</td>\n",
       "      <td>142519500</td>\n",
       "      <td>28826700</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-172286650</td>\n",
       "      <td>61064400</td>\n",
       "      <td>0</td>\n",
       "      <td>258770700</td>\n",
       "      <td>147548450</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-177305560</td>\n",
       "      <td>62423400</td>\n",
       "      <td>0</td>\n",
       "      <td>218321000</td>\n",
       "      <td>103438840</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>173208300</td>\n",
       "      <td>173208300</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34041780</td>\n",
       "      <td>168738600</td>\n",
       "      <td>202780380</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34341180</td>\n",
       "      <td>193347000</td>\n",
       "      <td>227688180</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34101660</td>\n",
       "      <td>214783500</td>\n",
       "      <td>248885160</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-188211600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>209776400</td>\n",
       "      <td>21564800</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>214335200</td>\n",
       "      <td>214335200</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>122278200</td>\n",
       "      <td>45863100</td>\n",
       "      <td>-228902500</td>\n",
       "      <td>-60761200</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-189971040</td>\n",
       "      <td>0</td>\n",
       "      <td>46256100</td>\n",
       "      <td>-262200000</td>\n",
       "      <td>-405914940</td>\n",
       "      <td>JM</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-263399400</td>\n",
       "      <td>-263399400</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-180171720</td>\n",
       "      <td>0</td>\n",
       "      <td>53926080</td>\n",
       "      <td>-204061200</td>\n",
       "      <td>-330306840</td>\n",
       "      <td>JM</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51150960</td>\n",
       "      <td>-873644400</td>\n",
       "      <td>-822493440</td>\n",
       "      <td>JM</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-30</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-181214820</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-996484200</td>\n",
       "      <td>-1177699020</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-07-31</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-208405040</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-888513000</td>\n",
       "      <td>-1096918040</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-01</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-217665000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-641029200</td>\n",
       "      <td>-858694200</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-217192500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-609272100</td>\n",
       "      <td>-826464600</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-03</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-220026850</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-606298500</td>\n",
       "      <td>-826325350</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-06</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-322332800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-910375200</td>\n",
       "      <td>-1232708000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-07</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-316293600</td>\n",
       "      <td>344292900</td>\n",
       "      <td>0</td>\n",
       "      <td>-912799300</td>\n",
       "      <td>-884800000</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-308503520</td>\n",
       "      <td>339666300</td>\n",
       "      <td>0</td>\n",
       "      <td>-728559000</td>\n",
       "      <td>-697396220</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-200084850</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-941508900</td>\n",
       "      <td>-1141593750</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-196708160</td>\n",
       "      <td>259357800</td>\n",
       "      <td>0</td>\n",
       "      <td>-930446400</td>\n",
       "      <td>-867796760</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-200207240</td>\n",
       "      <td>250494000</td>\n",
       "      <td>0</td>\n",
       "      <td>-974803500</td>\n",
       "      <td>-924516740</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-14</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-342181440</td>\n",
       "      <td>219462200</td>\n",
       "      <td>0</td>\n",
       "      <td>-879999900</td>\n",
       "      <td>-1002719140</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-198762480</td>\n",
       "      <td>229000000</td>\n",
       "      <td>0</td>\n",
       "      <td>-772306200</td>\n",
       "      <td>-742068680</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-195313680</td>\n",
       "      <td>183355200</td>\n",
       "      <td>0</td>\n",
       "      <td>-535051400</td>\n",
       "      <td>-547009880</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-199127400</td>\n",
       "      <td>192708600</td>\n",
       "      <td>0</td>\n",
       "      <td>-521513500</td>\n",
       "      <td>-527932300</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-205992480</td>\n",
       "      <td>112674000</td>\n",
       "      <td>0</td>\n",
       "      <td>-625840800</td>\n",
       "      <td>-719159280</td>\n",
       "      <td>J</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-21</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-203768180</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-527641400</td>\n",
       "      <td>-731409580</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-202020390</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-501053500</td>\n",
       "      <td>-703073890</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-200557500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-454419700</td>\n",
       "      <td>-654977200</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-204140000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-436149000</td>\n",
       "      <td>-640289000</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-346544100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-383295800</td>\n",
       "      <td>-729839900</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-202114770</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-377357800</td>\n",
       "      <td>-579472570</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-29</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-197557880</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-544636300</td>\n",
       "      <td>-742194180</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-30</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-338953280</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-355359500</td>\n",
       "      <td>-694312780</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-08-31</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-192098920</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-78618500</td>\n",
       "      <td>-270717420</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-03</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-193651900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-193651900</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-04</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-194687220</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-194687220</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-193040120</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-193040120</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-06</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-194263680</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-54416800</td>\n",
       "      <td>-248680480</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-07</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-193651900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-53833800</td>\n",
       "      <td>-247485700</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-195816660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-53477200</td>\n",
       "      <td>-249293860</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-163331400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-52693200</td>\n",
       "      <td>-216024600</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-163660200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-163660200</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-13</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-163209240</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-26759600</td>\n",
       "      <td>-189968840</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-14</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-162396040</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-162396040</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-161460860</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-161460860</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-163010260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-163010260</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-141501660</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-141501660</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-20</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-75246750</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-50801400</td>\n",
       "      <td>-126048150</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-21</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-70847100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-50801400</td>\n",
       "      <td>-121648500</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-35027630</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-35027630</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RB</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-27</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>RB</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-09-28</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-181684800</td>\n",
       "      <td>-181684800</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-08</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-5818500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-5818500</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-09</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-12972300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-12972300</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-10</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-12975600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9888000</td>\n",
       "      <td>-3087600</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-11</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-12850200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9216000</td>\n",
       "      <td>-3634200</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-12</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-12926100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>361922400</td>\n",
       "      <td>348996300</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-15</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>-13044900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>265863000</td>\n",
       "      <td>252818100</td>\n",
       "      <td>I</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-16</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54717500</td>\n",
       "      <td>54717500</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-17</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>55804100</td>\n",
       "      <td>55804100</td>\n",
       "      <td>I</td>\n",
       "      <td>RB</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-18</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>257050260</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>129973800</td>\n",
       "      <td>387024060</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-19</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>335510250</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>154618200</td>\n",
       "      <td>490128450</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-22</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>343782940</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>158143200</td>\n",
       "      <td>501926140</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-23</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>385984080</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>156738000</td>\n",
       "      <td>542722080</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-24</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>393300950</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>161356000</td>\n",
       "      <td>554656950</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-25</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>439302000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>53944800</td>\n",
       "      <td>493246800</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-26</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>443122290</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>443122290</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-29</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>484359160</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54290700</td>\n",
       "      <td>538649860</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-30</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>698018760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-262705400</td>\n",
       "      <td>435313360</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-10-31</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>681051200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-217056000</td>\n",
       "      <td>463995200</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-01</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>669742150</td>\n",
       "      <td>0</td>\n",
       "      <td>46780000</td>\n",
       "      <td>0</td>\n",
       "      <td>-155668700</td>\n",
       "      <td>560853450</td>\n",
       "      <td>RB</td>\n",
       "      <td>I</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-02</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>591985290</td>\n",
       "      <td>0</td>\n",
       "      <td>47120000</td>\n",
       "      <td>0</td>\n",
       "      <td>105804600</td>\n",
       "      <td>744909890</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018-11-05</th>\n",
       "      <th>道通期货</th>\n",
       "      <td>617402320</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>106901200</td>\n",
       "      <td>724303520</td>\n",
       "      <td>RB</td>\n",
       "      <td>HC</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "variety                  RB         HC          J        JM           I  \\\n",
       "date       会员简称                                                           \n",
       "2018-01-02 道通期货           0    5883000   20150000         0  -322324800   \n",
       "2018-01-03 道通期货  -843277220    6948000   20150000         0  -328889600   \n",
       "2018-01-04 道通期货  -919657470    6969600          0         0  -270848400   \n",
       "2018-01-05 道通期货  -929133280    6908400          0         0  -255162600   \n",
       "2018-01-08 道通期货  -727558320          0          0         0  -240303200   \n",
       "2018-01-09 道通期货  -725003820          0          0         0  -243177400   \n",
       "2018-01-10 道通期货  -733012360          0          0         0  -246189600   \n",
       "2018-01-11 道通期货           0          0          0         0  -284627000   \n",
       "2018-01-12 道通期货           0          0          0         0  -219907500   \n",
       "2018-01-15 道通期货           0          0          0         0  -211810600   \n",
       "2018-01-16 道通期货  -747756240          0          0         0  -208417500   \n",
       "2018-01-17 道通期货  -756481580          0          0         0  -208756800   \n",
       "2018-01-18 道通期货           0          0          0         0  -211326400   \n",
       "2018-01-24 道通期货           0          0          0         0  -205643600   \n",
       "2018-02-01 道通期货  -940098960          0          0         0  -239506800   \n",
       "2018-02-02 道通期货  -990081600          0          0         0  -241785600   \n",
       "2018-02-05 道通期货  -986820340          0          0         0  -274303500   \n",
       "2018-02-08 道通期货  -835491610          0          0         0  -299460000   \n",
       "2018-02-09 道通期货  -779687040          0          0         0  -220394400   \n",
       "2018-02-12 道通期货  -780627300          0          0         0  -220499200   \n",
       "2018-02-13 道通期货  -775360950          0          0         0  -222600000   \n",
       "2018-02-22 道通期货           0          0          0         0  -226962000   \n",
       "2018-02-23 道通期货           0          0          0         0  -328680000   \n",
       "2018-02-26 道通期货  -913425630          0          0         0  -359370000   \n",
       "2018-02-27 道通期货  -831192030          0          0         0  -358118000   \n",
       "2018-02-28 道通期货   -15719200          0          0         0  -321721600   \n",
       "2018-03-01 道通期货   -16928410          0          0         0  -329398000   \n",
       "2018-03-05 道通期货   855492800          0          0         0  -229135800   \n",
       "2018-03-06 道通期货   854712000          0          0         0  -115153200   \n",
       "2018-03-07 道通期货   840873600          0          0         0           0   \n",
       "2018-03-08 道通期货   815076010          0          0         0           0   \n",
       "2018-03-09 道通期货   804824000          0          0         0           0   \n",
       "2018-03-12 道通期货   805687210          0          0         0           0   \n",
       "2018-03-13 道通期货   807941260          0          0         0           0   \n",
       "2018-03-14 道通期货   792937860          0          0         0           0   \n",
       "2018-03-15 道通期货   905475780          0          0         0           0   \n",
       "2018-03-16 道通期货   901674630          0          0         0           0   \n",
       "2018-03-19 道通期货   883370880          0          0         0           0   \n",
       "2018-03-20 道通期货   697350390          0          0         0           0   \n",
       "2018-03-21 道通期货   691616100          0          0         0           0   \n",
       "2018-03-22 道通期货   692364120          0          0         0           0   \n",
       "2018-03-23 道通期货    52648960          0          0         0           0   \n",
       "2018-03-26 道通期货   615044020          0          0         0           0   \n",
       "2018-03-27 道通期货   544270410          0          0         0   967519000   \n",
       "2018-03-28 道通期货   868507000          0          0         0  1003671900   \n",
       "2018-03-29 道通期货   393772300          0          0         0  1014917600   \n",
       "2018-03-30 道通期货           0   97529040          0  76415760  1018870800   \n",
       "2018-04-02 道通期货           0   96646240          0  76008360  1026175600   \n",
       "2018-04-03 道通期货           0   72026960          0  76083840   695905100   \n",
       "2018-04-04 道通期货           0   71779000          0  76431300   378404400   \n",
       "2018-04-09 道通期货   250381320   75119760          0         0           0   \n",
       "2018-04-10 道通期货   227062920          0          0  89670360   488160000   \n",
       "2018-04-11 道通期货           0          0          0         0   658608200   \n",
       "2018-04-12 道通期货           0   35747850          0         0  1212556800   \n",
       "2018-04-13 道通期货           0   35917430          0  35535000   577610800   \n",
       "2018-04-16 道通期货           0   35090040          0  34360800   557612000   \n",
       "2018-04-17 道通期货           0   35500860          0  34904520  1188337800   \n",
       "2018-04-18 道通期货           0   36122100          0         0  1222995200   \n",
       "2018-04-19 道通期货           0          0          0  14842800  1292455800   \n",
       "2018-04-20 道通期货           0          0          0  13632000  1254144000   \n",
       "2018-04-23 道通期货           0          0          0         0  1103225200   \n",
       "2018-04-24 道通期货           0          0          0         0  1066130800   \n",
       "2018-04-25 道通期货           0          0          0         0  1069616800   \n",
       "2018-04-26 道通期货           0          0          0         0  1065454500   \n",
       "2018-04-27 道通期货           0          0          0         0   276092000   \n",
       "2018-05-04 道通期货    73932000          0          0         0   261075300   \n",
       "2018-05-07 道通期货   109796200          0          0         0   259403900   \n",
       "2018-05-08 道通期货   109752930          0          0         0   257355000   \n",
       "2018-05-09 道通期货   109501920          0          0         0   127661800   \n",
       "2018-05-10 道通期货   128153110          0          0         0   121986900   \n",
       "2018-05-11 道通期货   129184000          0          0         0   107166800   \n",
       "2018-05-14 道通期货   128353100          0          0         0     4276800   \n",
       "2018-05-15 道通期货    91189600          0  472514900         0  -380472400   \n",
       "2018-05-16 道通期货   148532400          0  406232400         0  -424434400   \n",
       "2018-05-17 道通期货   148613300          0  473639400         0  -371670200   \n",
       "2018-05-18 道通期货   109070080          0  507349700         0  -368387100   \n",
       "2018-05-21 道通期货   107735040  154920080  565401400         0  -356816000   \n",
       "2018-05-22 道通期货   108431520  152988180  573357700         0  -386671800   \n",
       "2018-05-23 道通期货   106701750          0  499740900         0  -298389000   \n",
       "2018-05-24 道通期货   107733580          0  466889500         0  -200146000   \n",
       "2018-05-25 道通期货           0          0          0         0  -197009700   \n",
       "2018-05-28 道通期货           0          0          0         0  -197508000   \n",
       "2018-05-29 道通期货           0          0          0         0  -187653900   \n",
       "2018-05-30 道通期货           0          0          0         0  -193375000   \n",
       "2018-05-31 道通期货           0          0          0         0  -777730800   \n",
       "2018-06-01 道通期货           0          0          0         0  -199435500   \n",
       "2018-06-04 道通期货           0          0          0         0  -182773500   \n",
       "2018-06-05 道通期货           0          0          0         0  -892669600   \n",
       "2018-06-06 道通期货           0          0          0         0  -934857700   \n",
       "2018-06-07 道通期货           0          0          0         0  -740241700   \n",
       "2018-06-08 道通期货           0          0          0         0  -697546500   \n",
       "2018-06-11 道通期货           0          0          0         0  -646704100   \n",
       "2018-06-12 道通期货           0          0          0         0  -703091200   \n",
       "2018-06-13 道通期货           0          0          0         0  -683897000   \n",
       "2018-06-14 道通期货           0          0          0         0  -691432800   \n",
       "2018-06-15 道通期货           0          0          0         0  -677998200   \n",
       "2018-06-19 道通期货           0          0          0         0   226080000   \n",
       "2018-06-20 道通期货           0 -183636150          0         0  -306092100   \n",
       "2018-06-21 道通期货           0 -297526560          0         0   228583800   \n",
       "2018-06-22 道通期货           0 -296602020          0         0  -306705600   \n",
       "2018-06-25 道通期货           0 -246425410          0         0  -316969800   \n",
       "2018-06-26 道通期货           0 -274150800          0         0  -310233000   \n",
       "2018-06-27 道通期货           0 -282063600          0         0  -226996400   \n",
       "2018-06-28 道通期货           0 -189279360          0         0  -297338900   \n",
       "2018-06-29 道通期货           0 -172025100          0         0  -304071000   \n",
       "2018-07-02 道通期货 -1036323120 -174950930   61094600         0   122556100   \n",
       "2018-07-03 道通期货 -1048153760 -184010040   61396600         0   123192000   \n",
       "2018-07-04 道通期货 -1082871390 -171479710   61668400         0   131716200   \n",
       "2018-07-05 道通期货 -1074810420 -178091210   60702000         0   217714800   \n",
       "2018-07-06 道通期货  -996630550 -177899260   60641600         0   224910000   \n",
       "2018-07-09 道通期货           0 -178821900   61275800         0   138276600   \n",
       "2018-07-10 道通期货           0 -174787400   61094600         0   142519500   \n",
       "2018-07-11 道通期货           0 -172286650   61064400         0   258770700   \n",
       "2018-07-12 道通期货           0 -177305560   62423400         0   218321000   \n",
       "2018-07-13 道通期货           0          0          0         0   173208300   \n",
       "2018-07-16 道通期货           0          0          0  34041780   168738600   \n",
       "2018-07-17 道通期货           0          0          0  34341180   193347000   \n",
       "2018-07-18 道通期货           0          0          0  34101660   214783500   \n",
       "2018-07-19 道通期货           0 -188211600          0         0   209776400   \n",
       "2018-07-20 道通期货           0          0          0         0   214335200   \n",
       "2018-07-23 道通期货           0          0  122278200  45863100  -228902500   \n",
       "2018-07-24 道通期货           0 -189971040          0  46256100  -262200000   \n",
       "2018-07-25 道通期货           0          0          0         0  -263399400   \n",
       "2018-07-26 道通期货           0 -180171720          0  53926080  -204061200   \n",
       "2018-07-27 道通期货           0          0          0  51150960  -873644400   \n",
       "2018-07-30 道通期货           0 -181214820          0         0  -996484200   \n",
       "2018-07-31 道通期货           0 -208405040          0         0  -888513000   \n",
       "2018-08-01 道通期货           0 -217665000          0         0  -641029200   \n",
       "2018-08-02 道通期货           0 -217192500          0         0  -609272100   \n",
       "2018-08-03 道通期货           0 -220026850          0         0  -606298500   \n",
       "2018-08-06 道通期货           0 -322332800          0         0  -910375200   \n",
       "2018-08-07 道通期货           0 -316293600  344292900         0  -912799300   \n",
       "2018-08-08 道通期货           0 -308503520  339666300         0  -728559000   \n",
       "2018-08-09 道通期货           0 -200084850          0         0  -941508900   \n",
       "2018-08-10 道通期货           0 -196708160  259357800         0  -930446400   \n",
       "2018-08-13 道通期货           0 -200207240  250494000         0  -974803500   \n",
       "2018-08-14 道通期货           0 -342181440  219462200         0  -879999900   \n",
       "2018-08-15 道通期货           0 -198762480  229000000         0  -772306200   \n",
       "2018-08-16 道通期货           0 -195313680  183355200         0  -535051400   \n",
       "2018-08-17 道通期货           0 -199127400  192708600         0  -521513500   \n",
       "2018-08-20 道通期货           0 -205992480  112674000         0  -625840800   \n",
       "2018-08-21 道通期货           0 -203768180          0         0  -527641400   \n",
       "2018-08-22 道通期货           0 -202020390          0         0  -501053500   \n",
       "2018-08-23 道通期货           0 -200557500          0         0  -454419700   \n",
       "2018-08-24 道通期货           0 -204140000          0         0  -436149000   \n",
       "2018-08-27 道通期货           0 -346544100          0         0  -383295800   \n",
       "2018-08-28 道通期货           0 -202114770          0         0  -377357800   \n",
       "2018-08-29 道通期货           0 -197557880          0         0  -544636300   \n",
       "2018-08-30 道通期货           0 -338953280          0         0  -355359500   \n",
       "2018-08-31 道通期货           0 -192098920          0         0   -78618500   \n",
       "2018-09-03 道通期货           0 -193651900          0         0           0   \n",
       "2018-09-04 道通期货           0 -194687220          0         0           0   \n",
       "2018-09-05 道通期货           0 -193040120          0         0           0   \n",
       "2018-09-06 道通期货           0 -194263680          0         0   -54416800   \n",
       "2018-09-07 道通期货           0 -193651900          0         0   -53833800   \n",
       "2018-09-10 道通期货           0 -195816660          0         0   -53477200   \n",
       "2018-09-11 道通期货           0 -163331400          0         0   -52693200   \n",
       "2018-09-12 道通期货           0 -163660200          0         0           0   \n",
       "2018-09-13 道通期货           0 -163209240          0         0   -26759600   \n",
       "2018-09-14 道通期货           0 -162396040          0         0           0   \n",
       "2018-09-17 道通期货           0 -161460860          0         0           0   \n",
       "2018-09-18 道通期货           0 -163010260          0         0           0   \n",
       "2018-09-19 道通期货           0 -141501660          0         0           0   \n",
       "2018-09-20 道通期货           0  -75246750          0         0   -50801400   \n",
       "2018-09-21 道通期货           0  -70847100          0         0   -50801400   \n",
       "2018-09-25 道通期货           0  -35027630          0         0           0   \n",
       "2018-09-26 道通期货           0          0          0         0           0   \n",
       "2018-09-27 道通期货           0          0          0         0           0   \n",
       "2018-09-28 道通期货           0          0          0         0  -181684800   \n",
       "2018-10-08 道通期货           0   -5818500          0         0           0   \n",
       "2018-10-09 道通期货           0  -12972300          0         0           0   \n",
       "2018-10-10 道通期货           0  -12975600          0         0     9888000   \n",
       "2018-10-11 道通期货           0  -12850200          0         0     9216000   \n",
       "2018-10-12 道通期货           0  -12926100          0         0   361922400   \n",
       "2018-10-15 道通期货           0  -13044900          0         0   265863000   \n",
       "2018-10-16 道通期货           0          0          0         0    54717500   \n",
       "2018-10-17 道通期货           0          0          0         0    55804100   \n",
       "2018-10-18 道通期货   257050260          0          0         0   129973800   \n",
       "2018-10-19 道通期货   335510250          0          0         0   154618200   \n",
       "2018-10-22 道通期货   343782940          0          0         0   158143200   \n",
       "2018-10-23 道通期货   385984080          0          0         0   156738000   \n",
       "2018-10-24 道通期货   393300950          0          0         0   161356000   \n",
       "2018-10-25 道通期货   439302000          0          0         0    53944800   \n",
       "2018-10-26 道通期货   443122290          0          0         0           0   \n",
       "2018-10-29 道通期货   484359160          0          0         0    54290700   \n",
       "2018-10-30 道通期货   698018760          0          0         0  -262705400   \n",
       "2018-10-31 道通期货   681051200          0          0         0  -217056000   \n",
       "2018-11-01 道通期货   669742150          0   46780000         0  -155668700   \n",
       "2018-11-02 道通期货   591985290          0   47120000         0   105804600   \n",
       "2018-11-05 道通期货   617402320          0          0         0   106901200   \n",
       "\n",
       "variety                黑色板块 max min  \n",
       "date       会员简称                      \n",
       "2018-01-02 道通期货  -296291800   J   I  \n",
       "2018-01-03 道通期货 -1145068820   J  RB  \n",
       "2018-01-04 道通期货 -1183536270  HC  RB  \n",
       "2018-01-05 道通期货 -1177387480  HC  RB  \n",
       "2018-01-08 道通期货  -967861520  HC  RB  \n",
       "2018-01-09 道通期货  -968181220  HC  RB  \n",
       "2018-01-10 道通期货  -979201960  HC  RB  \n",
       "2018-01-11 道通期货  -284627000  RB   I  \n",
       "2018-01-12 道通期货  -219907500  RB   I  \n",
       "2018-01-15 道通期货  -211810600  RB   I  \n",
       "2018-01-16 道通期货  -956173740  HC  RB  \n",
       "2018-01-17 道通期货  -965238380  HC  RB  \n",
       "2018-01-18 道通期货  -211326400  RB   I  \n",
       "2018-01-24 道通期货  -205643600  RB   I  \n",
       "2018-02-01 道通期货 -1179605760  HC  RB  \n",
       "2018-02-02 道通期货 -1231867200  HC  RB  \n",
       "2018-02-05 道通期货 -1261123840  HC  RB  \n",
       "2018-02-08 道通期货 -1134951610  HC  RB  \n",
       "2018-02-09 道通期货 -1000081440  HC  RB  \n",
       "2018-02-12 道通期货 -1001126500  HC  RB  \n",
       "2018-02-13 道通期货  -997960950  HC  RB  \n",
       "2018-02-22 道通期货  -226962000  RB   I  \n",
       "2018-02-23 道通期货  -328680000  RB   I  \n",
       "2018-02-26 道通期货 -1272795630  HC  RB  \n",
       "2018-02-27 道通期货 -1189310030  HC  RB  \n",
       "2018-02-28 道通期货  -337440800  HC   I  \n",
       "2018-03-01 道通期货  -346326410  HC   I  \n",
       "2018-03-05 道通期货   626357000  RB   I  \n",
       "2018-03-06 道通期货   739558800  RB   I  \n",
       "2018-03-07 道通期货   840873600  RB  HC  \n",
       "2018-03-08 道通期货   815076010  RB  HC  \n",
       "2018-03-09 道通期货   804824000  RB  HC  \n",
       "2018-03-12 道通期货   805687210  RB  HC  \n",
       "2018-03-13 道通期货   807941260  RB  HC  \n",
       "2018-03-14 道通期货   792937860  RB  HC  \n",
       "2018-03-15 道通期货   905475780  RB  HC  \n",
       "2018-03-16 道通期货   901674630  RB  HC  \n",
       "2018-03-19 道通期货   883370880  RB  HC  \n",
       "2018-03-20 道通期货   697350390  RB  HC  \n",
       "2018-03-21 道通期货   691616100  RB  HC  \n",
       "2018-03-22 道通期货   692364120  RB  HC  \n",
       "2018-03-23 道通期货    52648960  RB  HC  \n",
       "2018-03-26 道通期货   615044020  RB  HC  \n",
       "2018-03-27 道通期货  1511789410   I  HC  \n",
       "2018-03-28 道通期货  1872178900   I  HC  \n",
       "2018-03-29 道通期货  1408689900   I  HC  \n",
       "2018-03-30 道通期货  1192815600   I  RB  \n",
       "2018-04-02 道通期货  1198830200   I  RB  \n",
       "2018-04-03 道通期货   844015900   I  RB  \n",
       "2018-04-04 道通期货   526614700   I  RB  \n",
       "2018-04-09 道通期货   325501080  RB   J  \n",
       "2018-04-10 道通期货   804893280   I  HC  \n",
       "2018-04-11 道通期货   658608200   I  RB  \n",
       "2018-04-12 道通期货  1248304650   I  RB  \n",
       "2018-04-13 道通期货   649063230   I  RB  \n",
       "2018-04-16 道通期货   627062840   I  RB  \n",
       "2018-04-17 道通期货  1258743180   I  RB  \n",
       "2018-04-18 道通期货  1259117300   I  RB  \n",
       "2018-04-19 道通期货  1307298600   I  RB  \n",
       "2018-04-20 道通期货  1267776000   I  RB  \n",
       "2018-04-23 道通期货  1103225200   I  RB  \n",
       "2018-04-24 道通期货  1066130800   I  RB  \n",
       "2018-04-25 道通期货  1069616800   I  RB  \n",
       "2018-04-26 道通期货  1065454500   I  RB  \n",
       "2018-04-27 道通期货   276092000   I  RB  \n",
       "2018-05-04 道通期货   335007300   I  HC  \n",
       "2018-05-07 道通期货   369200100   I  HC  \n",
       "2018-05-08 道通期货   367107930   I  HC  \n",
       "2018-05-09 道通期货   237163720   I  HC  \n",
       "2018-05-10 道通期货   250140010  RB  HC  \n",
       "2018-05-11 道通期货   236350800  RB  HC  \n",
       "2018-05-14 道通期货   132629900  RB  HC  \n",
       "2018-05-15 道通期货   183232100   J   I  \n",
       "2018-05-16 道通期货   130330400   J   I  \n",
       "2018-05-17 道通期货   250582500   J   I  \n",
       "2018-05-18 道通期货   248032680   J   I  \n",
       "2018-05-21 道通期货   471240520   J   I  \n",
       "2018-05-22 道通期货   448105600   J   I  \n",
       "2018-05-23 道通期货   308053650   J   I  \n",
       "2018-05-24 道通期货   374477080   J   I  \n",
       "2018-05-25 道通期货  -197009700  RB   I  \n",
       "2018-05-28 道通期货  -197508000  RB   I  \n",
       "2018-05-29 道通期货  -187653900  RB   I  \n",
       "2018-05-30 道通期货  -193375000  RB   I  \n",
       "2018-05-31 道通期货  -777730800  RB   I  \n",
       "2018-06-01 道通期货  -199435500  RB   I  \n",
       "2018-06-04 道通期货  -182773500  RB   I  \n",
       "2018-06-05 道通期货  -892669600  RB   I  \n",
       "2018-06-06 道通期货  -934857700  RB   I  \n",
       "2018-06-07 道通期货  -740241700  RB   I  \n",
       "2018-06-08 道通期货  -697546500  RB   I  \n",
       "2018-06-11 道通期货  -646704100  RB   I  \n",
       "2018-06-12 道通期货  -703091200  RB   I  \n",
       "2018-06-13 道通期货  -683897000  RB   I  \n",
       "2018-06-14 道通期货  -691432800  RB   I  \n",
       "2018-06-15 道通期货  -677998200  RB   I  \n",
       "2018-06-19 道通期货   226080000   I  RB  \n",
       "2018-06-20 道通期货  -489728250  RB   I  \n",
       "2018-06-21 道通期货   -68942760   I  HC  \n",
       "2018-06-22 道通期货  -603307620  RB   I  \n",
       "2018-06-25 道通期货  -563395210  RB   I  \n",
       "2018-06-26 道通期货  -584383800  RB   I  \n",
       "2018-06-27 道通期货  -509060000  RB  HC  \n",
       "2018-06-28 道通期货  -486618260  RB   I  \n",
       "2018-06-29 道通期货  -476096100  RB   I  \n",
       "2018-07-02 道通期货 -1027623350   I  RB  \n",
       "2018-07-03 道通期货 -1047575200   I  RB  \n",
       "2018-07-04 道通期货 -1060966500   I  RB  \n",
       "2018-07-05 道通期货  -974484830   I  RB  \n",
       "2018-07-06 道通期货  -888978210   I  RB  \n",
       "2018-07-09 道通期货    20730500   I  HC  \n",
       "2018-07-10 道通期货    28826700   I  HC  \n",
       "2018-07-11 道通期货   147548450   I  HC  \n",
       "2018-07-12 道通期货   103438840   I  HC  \n",
       "2018-07-13 道通期货   173208300   I  RB  \n",
       "2018-07-16 道通期货   202780380   I  RB  \n",
       "2018-07-17 道通期货   227688180   I  RB  \n",
       "2018-07-18 道通期货   248885160   I  RB  \n",
       "2018-07-19 道通期货    21564800   I  HC  \n",
       "2018-07-20 道通期货   214335200   I  RB  \n",
       "2018-07-23 道通期货   -60761200   J   I  \n",
       "2018-07-24 道通期货  -405914940  JM   I  \n",
       "2018-07-25 道通期货  -263399400  RB   I  \n",
       "2018-07-26 道通期货  -330306840  JM   I  \n",
       "2018-07-27 道通期货  -822493440  JM   I  \n",
       "2018-07-30 道通期货 -1177699020  RB   I  \n",
       "2018-07-31 道通期货 -1096918040  RB   I  \n",
       "2018-08-01 道通期货  -858694200  RB   I  \n",
       "2018-08-02 道通期货  -826464600  RB   I  \n",
       "2018-08-03 道通期货  -826325350  RB   I  \n",
       "2018-08-06 道通期货 -1232708000  RB   I  \n",
       "2018-08-07 道通期货  -884800000   J   I  \n",
       "2018-08-08 道通期货  -697396220   J   I  \n",
       "2018-08-09 道通期货 -1141593750  RB   I  \n",
       "2018-08-10 道通期货  -867796760   J   I  \n",
       "2018-08-13 道通期货  -924516740   J   I  \n",
       "2018-08-14 道通期货 -1002719140   J   I  \n",
       "2018-08-15 道通期货  -742068680   J   I  \n",
       "2018-08-16 道通期货  -547009880   J   I  \n",
       "2018-08-17 道通期货  -527932300   J   I  \n",
       "2018-08-20 道通期货  -719159280   J   I  \n",
       "2018-08-21 道通期货  -731409580  RB   I  \n",
       "2018-08-22 道通期货  -703073890  RB   I  \n",
       "2018-08-23 道通期货  -654977200  RB   I  \n",
       "2018-08-24 道通期货  -640289000  RB   I  \n",
       "2018-08-27 道通期货  -729839900  RB   I  \n",
       "2018-08-28 道通期货  -579472570  RB   I  \n",
       "2018-08-29 道通期货  -742194180  RB   I  \n",
       "2018-08-30 道通期货  -694312780  RB   I  \n",
       "2018-08-31 道通期货  -270717420  RB  HC  \n",
       "2018-09-03 道通期货  -193651900  RB  HC  \n",
       "2018-09-04 道通期货  -194687220  RB  HC  \n",
       "2018-09-05 道通期货  -193040120  RB  HC  \n",
       "2018-09-06 道通期货  -248680480  RB  HC  \n",
       "2018-09-07 道通期货  -247485700  RB  HC  \n",
       "2018-09-10 道通期货  -249293860  RB  HC  \n",
       "2018-09-11 道通期货  -216024600  RB  HC  \n",
       "2018-09-12 道通期货  -163660200  RB  HC  \n",
       "2018-09-13 道通期货  -189968840  RB  HC  \n",
       "2018-09-14 道通期货  -162396040  RB  HC  \n",
       "2018-09-17 道通期货  -161460860  RB  HC  \n",
       "2018-09-18 道通期货  -163010260  RB  HC  \n",
       "2018-09-19 道通期货  -141501660  RB  HC  \n",
       "2018-09-20 道通期货  -126048150  RB  HC  \n",
       "2018-09-21 道通期货  -121648500  RB  HC  \n",
       "2018-09-25 道通期货   -35027630  RB  HC  \n",
       "2018-09-26 道通期货           0  RB  RB  \n",
       "2018-09-27 道通期货           0  RB  RB  \n",
       "2018-09-28 道通期货  -181684800  RB   I  \n",
       "2018-10-08 道通期货    -5818500  RB  HC  \n",
       "2018-10-09 道通期货   -12972300  RB  HC  \n",
       "2018-10-10 道通期货    -3087600   I  HC  \n",
       "2018-10-11 道通期货    -3634200   I  HC  \n",
       "2018-10-12 道通期货   348996300   I  HC  \n",
       "2018-10-15 道通期货   252818100   I  HC  \n",
       "2018-10-16 道通期货    54717500   I  RB  \n",
       "2018-10-17 道通期货    55804100   I  RB  \n",
       "2018-10-18 道通期货   387024060  RB  HC  \n",
       "2018-10-19 道通期货   490128450  RB  HC  \n",
       "2018-10-22 道通期货   501926140  RB  HC  \n",
       "2018-10-23 道通期货   542722080  RB  HC  \n",
       "2018-10-24 道通期货   554656950  RB  HC  \n",
       "2018-10-25 道通期货   493246800  RB  HC  \n",
       "2018-10-26 道通期货   443122290  RB  HC  \n",
       "2018-10-29 道通期货   538649860  RB  HC  \n",
       "2018-10-30 道通期货   435313360  RB   I  \n",
       "2018-10-31 道通期货   463995200  RB   I  \n",
       "2018-11-01 道通期货   560853450  RB   I  \n",
       "2018-11-02 道通期货   744909890  RB  HC  \n",
       "2018-11-05 道通期货   724303520  RB  HC  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "黑色板块=sz.copy()\n",
    "黑色板块=黑色板块[['RB','HC','J','JM','I','黑色板块']] \n",
    "黑色板块['max']=黑色板块[['RB','HC','J','JM','I']].idxmax(axis=1) \n",
    "黑色板块['min']=黑色板块[['RB','HC','J','JM','I']].idxmin(axis=1)\n",
    "黑色板块"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
